doctorevii2001
New Member
- Joined
- Nov 19, 2015
- Messages
- 21
I recently created my first spreadsheet using the VLOOKUP and it worked great! I thought it would be convenient to add the function to an existing spreadsheet, however something is not working right as it's returning me the dreaded #N/A for the results. Here's the formula I'm trying:
=(IF($P$1="","",(VLOOKUP($P$1,Table1,1,FALSE))))
the cell P1 is where I type in my search term (in this case a confirmation number from a supplier). Then in all the other columns on row 1 I want it to return the results that are associated with the confirmation number I type in P1.
Here's a screenshot showing the top row and some examples of the table below. Yes, the table is correctly specified in the formula as "Table1".
I appreciate any help!
http://1drv.ms/1LoIcT8
=(IF($P$1="","",(VLOOKUP($P$1,Table1,1,FALSE))))
the cell P1 is where I type in my search term (in this case a confirmation number from a supplier). Then in all the other columns on row 1 I want it to return the results that are associated with the confirmation number I type in P1.
Here's a screenshot showing the top row and some examples of the table below. Yes, the table is correctly specified in the formula as "Table1".
I appreciate any help!
http://1drv.ms/1LoIcT8