| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help with VLOOKUP
My formula in G10 is not working properly.
Here is the formula IF(D10="","",VLOOKUP(D10,BB$10:BC$167,2,0)) The problem: D is invoice# from 10 to 494 BB ranges from 10 to 167 and contains some invoice numbers that were verified BC ranges from 10 to 167 and contains number of problems with the invoice from 0 to whatever number. If D=BB then I need G to display the number of problems from BC I need D to remain blank if it does not match with BB. So far, my formula is not working. I get many #N/A Please help to correct this. Thank you |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
| Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
| Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
| Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
| Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
Threaded Mode
