Updating a formula Len(VLookup

[zone709]

=IFERROR(IF(LEN(VLOOKUP($H3,'Data (2)'!$D$2:$AH$204,2,0))=0,"",VLOOKUP($H3,'Data (2)'!$D$2:$AH$204,2,0)),"")

I use this formula above now to pull in numbers from the sheet called Data (2). If H3 Matches - D:AH on Data (2). It returns what's in column ,2 as you see.

I need to update this though.

I am looking now to match column H and Column B on current sheet to match D and H on Data (2) To Return what's in ,2
So H on current sheet needs to match D on Data (2) sheet which it does already but also need B on current sheet to match H on Data (2) in order to return what's in column ,2.

What I am trying to do here is have two matches before the returned results thanks.

 

[Fluff]

How about

=FILTER('Data (2)'!$F$2:$F$204,($H3='Data (2)'!$D$2:$D$204)*($B3='Data (2)'!$H$2:$H$204),"")

 

[zone709]

thank you for the help works great

 

[Fluff]

You're welcome & thanks for the feedback.

 

[zone709]

Hi I ran into something with the formulas twice. If I add both below it works fine but if there is zero I get #Value. Anyway i can get just blank if nothing is found.

=FILTER('Paychex (2)'!$M$2:$M$204,($H3='Paychex (2)'!$D$2:$D$204)*($B3='Paychex (2)'!$AM$2:$AM$204),"")+FILTER('Paychex (2)'!$AB$2:$AB$204,($H3='Paychex (2)'!$D$2:$D$204)*($B3='Paychex (2)'!$AM$2:$AM$204),"")


Also i used this in a column and it pulls in a date for me, but i need the date to be 2 days later. So I put +2 which it works, but if nothing is found i get #value again. Can i get just blank also if nothing is found?

=FILTER('Paychex (2)'!$E$2:$E$204,($H3='Paychex (2)'!$D$2:$D$204)*($B3='Paychex (2)'!$AM$2:$AM$204),"")+2

 

[Fluff]

Try wrapping them in IFERROR.

 

[zone709]

Try wrapping them in IFERROR.

Yes got it thank you.

 

[Fluff]

Glad it's sorted & thanks for letting us know.