[ 3 / biz / cgl / ck / diy / fa / ic / jp / lit / sci / vr / vt ] [ index / top / reports ] [ become a patron ] [ status ]
2023-11: Warosu is now out of extended maintenance.

/biz/ - Business & Finance

View post   
File: 27 KB, 468x483, 111.png [View same] [iqdb] [saucenao] [google]
54824771 No.54824771 [Reply] [Original]

I want to do sort of a Vlookup with 2 reference cells, without having to use concatenate to merge them to one reference column. Below, A and B are the same as E and F, just filtered upside down to mix them up. Can I somehow reference both A and B to return the appropriate value of the C column for the E and F?

>> No.54824812

>>54824771
Don't really know what you mean, but if you are still using Vlookup when you have index and match and Xlookup you are ngmi

>> No.54824814

>>54824771
why mix them up in the first place?

>> No.54824824

>>54824812
You're retarded. Vlookup is the original gmi

>> No.54824851

Try using sumifs. If concatenating A and B results in unique values that do not repeat in cells E and F, it should work

>> No.54824860

But to answer your question, no you cannot use a vlookup with more than 1 criteria. You could also try index/match

>> No.54824908

>>54824771
This is actually a decent use case for chat GPT, worth a shot, just be specific

>> No.54824909

You need to explain this better or show an example, your description doesn’t make sense

>> No.54824924

>>54824908
and here comes the phone poster doing the advertising and begging
that is how you make your products get faded

>> No.54824989
File: 23 KB, 701x349, image001.png [View same] [iqdb] [saucenao] [google]
54824989

Here you go OP

>> No.54824995

>>54824909
I want to return the values of C into G, based on the values of A:B to E:F. Like, reference "1111 bonuses" in A4:B4 to return the 468 into G21, which is also "1111 bonuses"

>> No.54824996

>>54824924
I Am confused anon. Wasn’t trying to shill but the OP seems to have a tough time translating his use case into words on the internet so maybe ai could take his use case and help

>> No.54825534

>>54824771
> import pandas as pd
> df = pd.read_xlxs('/path/to/spreadsheet.txt')
never uses excel again

>> No.54825907
File: 35 KB, 1165x395, excel.png [View same] [iqdb] [saucenao] [google]
54825907

>>54824995
you cant search for multiple criteria.
i think your best bet is to add 2 columns where you have =A1&B1 and another where you have =E1&F1
then in the G column you can do pic related

>> No.54826368

>>54824771
Just use python lol who's doing actual work in a spreadsheet in 2k23.
>Vlookup
What the fuck is that lmao

>> No.54826393
File: 17 KB, 516x193, sergey option.png [View same] [iqdb] [saucenao] [google]
54826393

I don't know what any of this means but you probably want pivot tables.

>> No.54826396

>>54826368
coding is gay

>> No.54826410

Your choices are vlookup(concatenation or INDEX MATCH MATCH,