How to have 2 vlookups on the same table?
I am trying to create a spreadsheet with multiple sheets. And I need to be able to have 2 V-lookups on the same sheet but looking up 2 separate data points.
You can make a difference in the Apple Support Community!
When you sign up with your Apple ID, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple ID, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
I am trying to create a spreadsheet with multiple sheets. And I need to be able to have 2 V-lookups on the same sheet but looking up 2 separate data points.
Could you post a screenshot of what you are trying to do? (shift-command-4, select area with cross-hairs, release, start new post here, and insert the image from the Desktop using the icon that looks like mountains and a moon).
Note that a sheet in Numbers has a blank canvas on which you place tables, charts, and other objects. So you would do a lookup on a table, not a sheet.
SG
So on the Bids Sheet. I am trying to be able to type a exhibitor number into column A and get back the Exhibitors Name in Column B (from the Master Sale List Table/Sheet), which I have gotten to work.
But I would also like to be able to get the Buyers Number that I am imputing into column C to give back the Buyers Names from the Buyers Total Master Table/Sheet), which it is giving me an error even tho I am using the same formula I used for the Exhibitors.
c_sites wrote:
giving me an error even tho I am using the same formula I used for the Exhibitors.
What formula are you using?
SG
How to have 2 vlookups on the same table?