[ 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

Search:

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

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?

Navigation
View posts[+24][+48][+96]