Noel Lackey
Member
Hi,
I have a vlookup formula that works on my laptop and home computer but if I try it on my work computer I get N/A, I have two sheets, one is called LOOKUP and the other is called RDS. The LOOKUP table contains budget information for various parts of a business. I want to be able to run the Vlookup and have it put the figures from the cells in the LOOKUP sheet into cells in the RDS sheet.
I have called the table in the LOOKUP sheet "venuelookup"
Here is the formula:=vlookup(A1,venuelookup,3,false)
I immediately get N/A on my work computer but it works fine on my laptop and home computer. Does anyone know of any obvious boxes that need to be ticked or unticked or any other reason for this? I am running Excel 2013 on Windows 10.
Thanks,
Noel
I have a vlookup formula that works on my laptop and home computer but if I try it on my work computer I get N/A, I have two sheets, one is called LOOKUP and the other is called RDS. The LOOKUP table contains budget information for various parts of a business. I want to be able to run the Vlookup and have it put the figures from the cells in the LOOKUP sheet into cells in the RDS sheet.
I have called the table in the LOOKUP sheet "venuelookup"
Here is the formula:=vlookup(A1,venuelookup,3,false)
I immediately get N/A on my work computer but it works fine on my laptop and home computer. Does anyone know of any obvious boxes that need to be ticked or unticked or any other reason for this? I am running Excel 2013 on Windows 10.
Thanks,
Noel
Last edited: