I know that this is not a common question. It would be too long to explain why I'm asking this. Are there any type of VLOOKUPs I could create with the data in the attached spreadsheet? If so, what?

Thank you,
Karen

Attached Files

Data.xlsx (12.1 KB, 6 views)

Might I draw your attention to the fact that you posted various times on this forum, and often did not bother to acknowledge answers given or even say if your problem was solved?
https://www.msofficeforums.com/excel...ear-month.html
https://www.msofficeforums.com/excel...readsheet.html
etc...

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thank you for letting me know. I usually make it a point to acknowledge answers or mark the problem "solved." but I had some health issues after that and never got around to it.

And what you want to be returned from this table?

When the price, then which one - as there are several of them for every product, department, and order?

With current table design, you can get the average price per product, department, and order.

To get the specific price from table, you need additional condition fields, adding of which makes the combination of conditions unique. P.e. a field, which indicates, how many times the current combination of product, department, and order, did appear starting from top row of table.

Both those possibilities are presented in attached file

Attached Files

Data.xlsx (13.5 KB, 5 views)

Thank you for your help. It doesn't matter what is returned from this table. I just want to see if VLOOKUP can be used with this data set.

Thank you so much for your help. Much appreciated.

Best,
Karen

Thank you for your help. I changed the data and now I’m using XLOOKUP.

No! It cant (unless you want the value from topmost row matching the search criteria only)!

Thank you! If you time, would you kindly demonstrate that?

Can you also explain why this data is not set up to use VLOOKUP?

Thank you,
Karen

Thank you for your help. I changed the data and now I’m going to use XLOOKUP.

Are you really using XL2021 or rather 365? The latter has many lookup functions that will spill

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Hello,

I'm using 365.

I actually have a different spreadsheet that I would greatly appreciate having help with.

Please see attached file: XLOOKUP
How can XLOOKUP be used in B2:B5 and C2:C5 to lookup which vendor & department in the Data tab are associated with the order number? The green shaded cells in the XLOOKUP Data tab are what I want returned using XLOOKUP.

Any help would be greatly appreciated.

Thank you,
Karen

Attached Files

XLOOKUP.xlsx (14.2 KB, 4 views)

MS 365 is not an option in the drop-down. That's why I chose 2021.

Personally, once you have taken a minute to finalize your threads, I will be glad to have a look at your problem.

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thank you, I finalized the threads.

Nothing has changed...

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post