Lookup value to multiple sheets

Hi Anyone,

I have a four tab in the one sheet. I want lookup value in the form column. Every sheet very similar in the key columns included same sheets.

 

LR No is Key columns, I want LR No to No Boxes

Capture.PNG

โ€ƒ

 

0 2 73
2 REPLIES 2

See this

https://www.googlecloudcommunity.com/gc/Tips-Tricks/FAQ-FILTER-LOOKUP-MAXROW-MINROW-REF-ROWS-and-SEL...

There are many ways to lookup values in other tables.

You need to choose the appropriate one(s) based on your use case.

Top Labels in this Space