Vlookup?

So, i am trying to see if a number is in a row of cells. If i am searching to see if a1 is in c2:i2 then vlookup isn’t working. It would only return the row i am asking and would need to copy into multiple cells. I could stack vlookups, or is there an easier way to accomplish this?

iPad Pro, 11-inch, 4th Gen, Wi-Fi

Posted on Nov 24, 2022 8:31 AM

Reply

Similar questions

VLOOKUP How can I get VLOOKUP to return text. The error message indicated that "Argument 3 is expecting a numeral" but finds the text that I want it to find. I will attach screenshots to elucidate. I have tried entering Argument 3 by typing and clicking with no joy. I've also tried to numbered the column. I'm a complete nube at this, so I'm not sure where to go from here. I would like it to return with the info that it finds. Any help is welcome!
1779 6
Return a value from a different worksheet I am trying to associate cell values from a separate workbook file. In Excel I used the VLOOKUP. How do I do the same in Numbers?
338 6
Vlookup help Hello everyone. I am struggling to understand the V-lookup feature, perhaps I don't need to use it for the task I am trying to complete.. I have a 2 columns of data, with some of the data in both columns Is it possible to use a formula like Vlookup to discover which numbers from column A are also in column B? If so can someone please share it and where I would paste it in the sheet? (I have a much bigger set of data than this screenshot, this is just a sample of what I'm hoping to do with a formula) Thank you very much for your help!
545 8

4 replies

Level 10

302,294 points

Nov 24, 2022 2:32 PM in response to philliphalljr

Perhaps the Numbers User Guide for iPad - available both as an online resource and as a download for Apple Books - will provide useful insight:

Numbers User Guide for iPad - Apple Support

https://books.apple.com/gb/book/numbers-user-guide-for-ipad/id1450570987

Here is another useful resource:

Numbers - Function list - Apple

Reply

Level 10

225,840 points

Nov 24, 2022 8:38 AM in response to philliphalljr

Using what app on what platform?

This is the iPad forum. Are you using an iPad or a Mac? Are you using Numbers? Excel? Something else?

Reply

Nov 24, 2022 2:10 PM in response to KiltedTim

Sorry, yea, ipad pro 11” numbers app

Reply

Nov 25, 2022 3:40 AM in response to LotusPilot

Thanks, i have looked at both of those and they don’t explain what i am trying to accomplish.

Reply

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Vlookup?

Welcome to Apple Support Community

A forum where Apple customers help each other with their products. Get started with your Apple Account.

Learn more Sign up