Forum Discussion
formula needed for VLOOKUP
- Hi, is it possible to lookup for price only in column C, but to search in columns A and C, but exclude column B. Thx
Yes. that is possible. Here are the steps:
Open both the workbook with the lookup range and the workbook where you want the formula.
Select the cell where you want the formula.
Start typing the formula, for example
=SVERWEIS(A2;
Now use the mouse or the keyboard to switch to the other workbook.
Activate the sheet with the lookup range.
Select the lookup range. You will see something like
=SVERWEIS(A2;'[ExterneDatei.xlsx]Blatt 2'!$A$2:$B$100
Complete the formula the normal way:
=SVERWEIS(A2;'[ExterneDatei.xlsx]Blatt 2'!$A$2:$B$100;2;FALSCH)
Press Enter and check whether it returns the expected result.
If it does, switch to the other workbook and close it. The formula will now include the path of the other workbook:
=SVERWEIS(A2;'C:\Excel\[ExterneDatei.xlsx]Blatt 2'!$A$2:$B$100;2;FALSCH)
Save the workbook.
Of course than we have to make sure, that the currency in column is set up to currency EURO from settings.
Thx
I'm afraid I don't understand. Could you attach a sample workbook and explain in detail what you want?
HansVogelaar
Hi, thank you. Pls see attached files. I have entered in both data. the data in buc estimate excel has to vlookup from buc taxes (figures) and currency and place in dedicated column. So the formula should either place 0 as figure or the dedicated figure from buc taxes. Hope you understand. BestThere was no way I could have guessed that from your previous post.
This is more complicated than you'd think, because it depends on the number format of the cells in the buc taxes sheet. We need VBA to read the number format, so the buc estimates workbook is now a .xlsm, and you'll have to allow macros when you open it. Also, the buc taxes workbook must be open in Excel for it to work.