VLOOKUP over multiple sheets is NOT working?

Question

VLOOKUP over multiple sheets is NOT working?

I have ported a working Excel sheet into the iOS version on numbers and for what ever reason, the formulas are not working. I have cleared all the cell data and marked with the appropriate field type e.g. number/text.

The idea is that on SHEET A there is a table listing part numbers, descriptions, list price, discount and product group. The idea is that the left cell you enter the part number and the descrtipion and price are populated with the return values.

For example Sheet 1

Part no Description Group

192512 Self Forming Screw A420 Accessories F 80 1.04 40

Sheet 2:

I enter the part number 192512 and expect colum B to be able to match to the data on Sheet 1?

Any ideas, I just get error after error?

Posted on Mar 29, 2012 1:15 AM

Reply

Answer 1

jaxjason

Level 5

5,063 points

Mar 29, 2012 1:21 PM in response to MrThompsonESQ

can you post the exact equation? I just made a vlookup on my ipad and was able to reference a table on another sheet and get the right answer. There might be something we can find if we see the equation.

Jason

Reply

Answer 2

Jun 12, 2012 2:40 PM in response to jaxjason

http://db.tt/h5WE8bNz

I have put the file in question in my dropbox. The idea behind this is that if a number is entered in column A on the quotation sheet the return value would be the description in column B on the Gross PL sheet. I also need to call the price which also matches the part number listed.

I have tried many attempts. ok fine in Excel but I really need to have on my iPad as I don't always have access to the Internet?

Hope you can help!

Reply