hi,
could anyone help me with the below query?
I'll need to pick up the rates from sheets "SYD" & "BNE" by info from column A of "Summary", which means if the info in column A is "sydney", the formula should pick up the rates from sheet "SYD", if it's "brisbane", the formula should pick up the rates from sheet "BNE".
Also, the rate should be matched by the column B,C & D from "summary" page.
Thanks,
M
Bookmarks