Mar 26 2023 02:14 AM
You can use the VLOOKUP function to find a piece in an Excel table with a value. The syntax of the VLOOKUP function is as follows:
=VLOOKUP(Lookup_Value,Table_Array,Col_Index_Num,Range_Lookup)
For example, if you want to find a piece called “X” in a table named “Y” with values in columns A and B, you can use the following formula:
=VLOOKUP("X",Y!A:B,2,FALSE)
This formula looks up “X” in column A of the table named “Y” and returns the corresponding value from column B.
But when it comes to value labeling...
Can label a cell with text by right-clicking the cell and selecting "Format Cell". Click on the "Numbers" tab and select "Custom".
In the Type field, enter the following text:
Default "Piece". or whatever lettering you like.
Click on OK to save the changes .
I hope this helps!