Forum Discussion

anupambit1797's avatar
anupambit1797
Iron Contributor
May 14, 2025
Solved

Vlookup or any better function

Dear Experts,                  Greetings! I have a data like below:- Sheet 1 & 2, and have to fetch the data from 2 -> 1.   If , I use Vlookup with True(approximate match) then it populates ...
excel
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    May 14, 2025

    Does this do what you want?

    =LET(t, IFERROR(LOOKUP(A2, '2'!A:A), ""), IF(COUNTIF(B$1:B1, t), "", t))

HansVogelaar's avatar
HansVogelaar
MVP
May 14, 2025

That would be

=IF(COUNTIF(B$1:B1, IFERROR(LOOKUP(A2, '2'!A:A), "")), "", IFERROR(LOOKUP(A2, '2'!A:A), ""))

Resources