Mark Wood
asked on
VLookup help needed
I have a spreadsheet where i am trying to do a vlookup. i have done this several times before so i am not sure why it isnt working.
So on the document tab of my spreadsheet i have the following =IFERROR(VLOOKUP(C5,Table1 ,1,FALSE), ""). C5 is the name of a compute, Table1 is on my setup tab which has computer name,ip, etc in it.
please help.
So on the document tab of my spreadsheet i have the following =IFERROR(VLOOKUP(C5,Table1
please help.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you sir .. it worked perfectly
You're welcome Mark! Glad it worked as desired.
ASKER
Compliance-Status-Report-SCARS-Temp.xlsx