| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup query
Hello Everyone
I have two worksheets if the number in sheet 1 cell B2 is in column B of sheet 2 (say B36) I want the number in A36 to be copied to sheet one. I have written the following but keep getting #N/A - What am I doing wrong please? =IF(COUNTIF(sheet 2!$B$2:$B$576,B2),VLOOKUP(B2,sheet 2!$A$2:$K$511,1,0),0) -- Thanks as always |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If and Vlookup Query | Excel Discussion (Misc queries) | |||
| VLOOKUP query | Excel Worksheet Functions | |||
| IF/VLOOKUP Query | Excel Discussion (Misc queries) | |||
| VLookup query | Excel Discussion (Misc queries) | |||
| Vlookup query | Excel Worksheet Functions | |||
Threaded Mode
