Hi All,

Please see attached. Here I've used VLOOKUP now. Actually I want value 'C' at clouded B/2 location. Instead of this VLOOKUP any other option available? Can you please help me? Thanks in advance. Excel file also attached here for reference.

Regards,
Sunil Thomas

Attached Images

Capture.JPG (43.1 KB, 22 views)

Attached Files

Test.xlsx (9.3 KB, 13 views)

Hi and welcome
here is one of the many sites that describes this technique
https://fiveminutelessons.com/learn-...le-values-list

__________________
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

With all due respect to the Moderator I think there is a bit more in it than what is explained in the fiveminuteslessons link.

If I understand it correctly, OP wants to use a normal VLOOKUP-formula if there is no duplicates for a given number in column A and another formula if there is duplicates.

If you can accept helper cells as shown in column F, I think you can use the array formula in column G.

I have not done any serious testing, so come back if you get problems.

Attached Files

Lookup_Test.xlsx (14.4 KB, 13 views)