Hi Guys, I am having a trouble creating a VLOOKUP formula on my database. I have 4 Sheets (Region1, Region 2, Region 3, Region 4).
Now I want to have 2 VlookUP to retrieve the data.
For example:
In B2, If I put Region 1 then it will VlookUP on the Region 1 Sheet the Similar Name I entered in B3. Then If I put Region 2, it will retrieve info from Region 2 Sheet.
I tried adding IF Function but it says " Too much argument" Something like that. Thank you in advance.
here is my sample WB:
Bookmarks