I want to find a value in a sheets wether it exists in another sheets.
2006-12-10 14:30:22 · 2 answers · asked by Pakcik Kantin 3 in Computers & Internet ➔ Software
Your question seems incomplete. Give an example of what you are looking to do.
Using VLOOKUP or HLOOKUP you can return data from other sheets.
Using a combination of INDIRECT, ADDRESS and CELL you can do all sorts of interesting things.
If you are looking to find out whether a certain value exists in a cell or range, you can use COUNTIF.
2006-12-11 18:13:51 · answer #1 · answered by Cribbage 5 · 1⤊ 0⤋
You can use one of these functions:
1- COUNTIF, will count the number of cells that match certain criteria in a range (I think it is the most suitable one here for you)
2- MATCH, to search for an item in a ONE-DIMENSION array
3- DCOUNTA, will search for an item in a column based on criteria in a specified range.
For a sample on each of the above, you are free to mail me here, or if you are not familiar with functions.
Enjoy my profile, I am the VBAXLMan
2006-12-13 03:23:28 · answer #2 · answered by Anonymous · 0⤊ 0⤋