๋ณธ๋ฌธ ๋ฐ”๋กœ๊ฐ€๊ธฐ

VLOOKUP ์œ ์‚ฌ๊ฐ’1

[์—‘์…€] VLOOKUP True ์œ ์‚ฌํ•œ ๊ฐ’ ์ฐพ๊ธฐ :: ๋งˆ์ด์ž๋ชฝ VLOOKUP ์œ ์‚ฌํ•œ ๊ฐ’ ์ฐพ๊ธฐ VLOOKUP ํ•จ์ˆ˜์˜ ๋งˆ์ง€๋ง‰ ์ธ์ž ๊ฐ’ [range_lookup] ๊ฐ’์€ ์ƒ๋žตํ•˜๋ฉด FALSE๋กœ ์ง€์ •๋˜์–ด ์ •ํ™•ํžˆ ์ผ์น˜ํ•˜๋Š” ๊ฐ’์„ ์ฐพ๋Š”๋‹ค.์ด๋ฒˆ ๊ธ€์—์„œ๋Š” TRUE๋กœ ์„ค์ •ํ•˜์—ฌ ์œ ์‚ฌํ•œ ๊ฐ’์„ ์ฐพ๋Š” ์ž‘์—…์„ ํ• ๊ฑฐ๋‹ค.VLOOKUP ํ•จ์ˆ˜์— ๋Œ€ํ•œ ๋‚ด์šฉ์€ ์•„๋ž˜ ๋งํฌ๋ฅผ ์ฐธ์กฐํ•œ๋‹ค.http://myjamong.tistory.com/63 ์ž‘์—… ๋‚ด์šฉ์ž๋ชฝ์Šˆํผ์—์„œ ์‡ผํ•‘์„ ํ•˜๋ฉด ๊ตฌ๋งค๊ธˆ์•ก์— ๋”ฐ๋ผ ํ• ์ธ์œจ์ด ๋‹ค๋ฅด๊ฒŒ ์ ์šฉ๋œ๋‹ค.๊ตฌ๋งค๊ธˆ์•ก์— ๋”ฐ๋ผ ํ• ์ธ์ด ์ ์šฉ๋œ ๊ธˆ์•ก์ด ํ‘œ์‹œ๋˜๋Š” ํ‘œ๋ฅผ ๋งŒ๋“ค๋ ค๊ณ  ํ•œ๋‹ค. ๊ฒฐ๊ณผ C11์…€ ๋‚ด์šฉ1=VLOOKUP(B11,$B$4:$C$7,2,TRUE)csB11 : 8000(๊ตฌ๋งค๊ธˆ์•ก)$B$4:$C$7 : ์ž๋ชฝ์Šˆํผ ๊ตฌ๋งค๊ธˆ์•ก๋ณ„ ํ• ์ธํ‘œ(์ตœ์†Œ,ํ• ์ธ์œจ)2 : 2๋ฒˆ์งธ ์—ด(ํ• ์ธ์œจ)TRUE : ์œ ์‚ฌํ•œ ๊ฐ’ ์ฐพ๊ธฐ๊ฒฐ๊ณผ : 800.. 2019. 1. 17.