mistersteve
Board Regular
- Joined
- Aug 18, 2014
- Messages
- 110
- Office Version
- 365
Hello all,
Please forgive me if I don't explain properly
Using vlookup from another spreadsheet
I select from the table array as below and select column C as result
However, there are in some instances there is a part number in column B
Therefore, can it be possible to ignore Column A as first left column and choose Column B whenever there is a part number present
A B C
Group Part Number Discount
1 P302 15
2 P311 40
3 P179 25
4 P179 12345 57.62
Hoping this can be answered and thankyou in advance
Please forgive me if I don't explain properly
Using vlookup from another spreadsheet
I select from the table array as below and select column C as result
However, there are in some instances there is a part number in column B
Therefore, can it be possible to ignore Column A as first left column and choose Column B whenever there is a part number present
A B C
Group Part Number Discount
1 P302 15
2 P311 40
3 P179 25
4 P179 12345 57.62
Hoping this can be answered and thankyou in advance
